
CREATE TABLE Base_StaffOrganize
(
	StaffOrganize_Id VARCHAR2(50) NOT NULL PRIMARY KEY,
	Organization_ID VARCHAR2(50),
	User_ID VARCHAR2(50),
	CreateDate date default(sysdate),
	CreateUserId varchar2(50),
	CreateUserName varchar2(50)
);

/*

SET ANSI_PADDING OFF
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职员组织关系表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_StaffOrganize'
GO

ALTER TABLE [dbo].[Base_StaffOrganize]  WITH CHECK ADD  CONSTRAINT [FK_Base_StaffOrganize_Base_Organization] FOREIGN KEY([Organization_ID])
REFERENCES [dbo].[Base_Organization] ([Organization_ID])
GO

ALTER TABLE [dbo].[Base_StaffOrganize] CHECK CONSTRAINT [FK_Base_StaffOrganize_Base_Organization]
GO

ALTER TABLE [dbo].[Base_StaffOrganize]  WITH CHECK ADD  CONSTRAINT [FK_Base_StaffOrganize_Base_UserInfo] FOREIGN KEY([User_ID])
REFERENCES [dbo].[Base_UserInfo] ([User_ID])
ON DELETE CASCADE
GO

ALTER TABLE [dbo].[Base_StaffOrganize] CHECK CONSTRAINT [FK_Base_StaffOrganize_Base_UserInfo]
GO

ALTER TABLE [dbo].[Base_StaffOrganize] ADD  CONSTRAINT [DF_Base_StaffOrganize_CreateDate]  DEFAULT (getdate()) FOR [CreateDate]
GO

*/